---
title: DB-CLL-062 — Check whether a hearing location has active schedule rows
summary: Check whether a hearing location has active schedule rows
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-062 — Check whether a hearing location has active schedule rows

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-062 |
| Operation type | R |
| Execution method | Text |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Inline text SQL |
| Business object | clsHearingLocation.CanDeleteLocation |
| Criteria property | n/a (custom method) |
| Lifecycle method | n/a |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| HearingLocationID | Input | NUMBER | N/A | Hearing location identifier being checked for delete |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [HEARING_LOCATION](../database-tables.md#hearing_location) | SELECT | HEARING_LOCATION_SEQ_NUM |
| [SCHEDULE](../database-tables.md#schedule) | SELECT | referencing rows |

## Sample SQL

```sql
Select
  Count(*)
From
  SCHEDULE
Where
  SCHEDULE.HEARING_LOCATION_SEQ_NUM = :HearingLocationID
```

## Operations and processes

- [Manage hearing locations](../operations/manage-hearing-location.md)

## Business rules

- [BR-CLM-LGL-012](../business-rules.md#br-clm-lgl-012-hearing-location-requires-valid-code%2C-name%2C-state%2C-and-city)
- [BR-CLM-LGL-013](../business-rules.md#br-clm-lgl-013-hearing-location-cannot-be-deleted-while-referenced-by-schedule-rows)

> **Note:** Statements marked with `*` were inferred from code structure, naming
> conventions, or contextual evidence where direct confirmation was not available
> in source artifacts. Statements marked with `**` could not be confirmed; treat
> as unknown until verified.

## Sources

- `SAIF.Business.Claim.Legal\TableMaint\clsHearingLocation.vb`